-- =========================================
-- Author: Jacob Gable
-- Created: 02.00.2009
-- Notes: Creation of FitnessGoal table.
-- 
-- 
-- =========================================

IF OBJECT_ID('dbo.FitnessGoal', 'U') IS NOT NULL
  DROP TABLE dbo.FitnessGoal
GO

CREATE TABLE dbo.FitnessGoal
(
	GoalId int identity(1,1) NOT NULL, 	
	UserId uniqueidentifier foreign key references aspnet_users(UserId) NOT NULL,
	Title datetime NULL, 
	StartVal decimal NOT NULL,
	GoalVal decimal NOT NULL,
	IsActive bit NOT NULL,
	ts timestamp NULL,
    CONSTRAINT PK_Goal PRIMARY KEY (GoalId)
)
GO
